home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presen…tion Library 1994 January / ARPL-Jan94-Disc2of2-Partner-Edition.iso / Applications / Integrated Software / MUSE 1.1 / Extras / Samples Folder / ClearAccess™ Samples / Oracle SQL Query Folder / Operating Data Update < prev    next >
Encoding:
Text File  |  1991-10-03  |  561 b   |  30 lines  |  [TEXT/CL/A]
  1. /* @Connect VIA "ORACLE" HOST "LOCAL" USER "OCCAM" PASSWORD "MUSE" */
  2.  
  3. /* @Prompt "Select operating data for which fiscal year?", YearVar */
  4.  
  5. SELECT 
  6.   FISCAL_YEAR, 
  7.   COUNTRY, 
  8.   PRODUCT_LINE, 
  9.   SUM(PULP_SALES), 
  10.   SUM(COST_OF_FRUIT), 
  11.   SUM(COST_OF_PRODUCTION), 
  12.   SUM(ADVERTISING), 
  13.   SUM(MARKETING), 
  14.   SUM(PROMOTIONS), 
  15.   SUM(OVERHEAD), 
  16.   SUM(FRUIT_PURCHASED), 
  17.   SUM(LOTS_PURCHASED), 
  18.   SUM(QUOTA) 
  19.     FROM  GENERAL_ACCOUNTING 
  20. WHERE
  21.   FISCAL_YEAR LIKE '%&YearVar%'
  22. GROUP BY  
  23.   FISCAL_YEAR, 
  24.   COUNTRY, 
  25.   PRODUCT_LINE; 
  26.  
  27. Headers();
  28. PrintAll;
  29. COMMIT;
  30.